create table sungjuk (
	sjno number(5) primary key,
	name VARCHAR2(15) not null,
	kor number(3) not null,
	eng number(3) not null,
	mat number(3) not null,
	tot number(3) DEFAULT 0,
	avgs number( 5, 2 ) DEFAULT 0.0,
	grd VARCHAR2(3) DEFAULT '가',
	regdate date DEFAULT sysdate
);

create sequence sjno
nocache;

insert into sungjuk 
( sjno, name, kor, eng, mat, tot, avgs, grd )
values ( sjno.nextval, '태희', 98, 98, 97,
	297, 97.12, '수');

select * from sungjuk;









